package org.geektimes.projects.user.repository;

import org.geekbang.projects.orm.annotation.Metadata;

/**
* 数据库创建  
* @author : KangNing Hu
*/
public interface DMLMapper {


	@Metadata("drop table  users")
	void dropTable();

	@Metadata("CREATE TABLE users(\n" +
			"id INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),\n" +
			"name VARCHAR(16) NOT NULL,\n" +
			"password VARCHAR(64) NOT NULL,\n" +
			"email VARCHAR(64) NOT NULL,\n" +
			"phone_number VARCHAR(32) NOT NULL)")
	void createTable();
}
